import pymysql

db = pymysql.connect(
    host='localhost',
    port=3306,
    database='jiangsu',
    user='root',
    password='root',
    charset='utf8'
)

cursor = db.cursor()
sql = "delete from student where s_id in ('11', '12','13', '14')"
cursor.execute(sql)
db.commit()  # 提交事务

# 关闭链接
cursor.close()
db.close()
